Input translation - understading better

Notes/Domino 8 Forum

Subject:

Hi, Dave.

If I understood correctly, you said that, in the case of names fields, the input translation only changes the field value in the front-end document, not the back-end document.

The problem is that I don't get a consistent behaviour in Lotus Notes querying documents with fields with input translation from the database. As I said, in a specific case, I have code in the form of a document of type Y that queries documents of type X (doc type X has a input translation formula in a names field). Notes returns to me the value of a names field (of document of type X) in canonical format *only* if the document (of type X) is opened at same time; otherwise I get the name in abbreviated format. That made me think that the input translation formula in a field applies to the back-end document too, but only after the doc is closed.

I think this behavior is awkward. I'd expect to always get the same value in a document field, unless the document is edited and saved.

Any help is appreciated.

Feedback response number WEBB8TAJQZ created by ~Lisa Umgeroplopakol on 04/12/2012